Columns

Grants

Dependencies

Details

Triggers

Errors


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS INSERTABLE UPDATABLE DELETABLE
ACTIVITY_TYPE VARCHAR2(100) No null 3 null NO NO NO
TITLE VARCHAR2(400) Yes null 4 null NO NO NO
CREATED_ON DATE Yes null 5 null NO NO NO
CREATED_ON_FY NUMBER Yes null 6 null NO NO NO
DAYS_OPEN NUMBER Yes null 7 null NO NO NO
STATUS VARCHAR2(100) Yes null 8 null NO NO NO
ACTIVITY_DATE DATE Yes null 9 null NO NO NO
ACTIVITY_DATE_FY NUMBER Yes null 10 null NO NO NO
OWNING_UNIT VARCHAR2(400) Yes null 11 null NO NO NO
LEAD VARCHAR2(400) Yes null 12 null NO NO NO
SUPPORT_PERSONNEL VARCHAR2(4000) Yes null 13 null NO NO NO
ASSOCIATIONS_COUNT NUMBER Yes null 14 null NO NO NO
ATTACHMENTS_COUNT NUMBER Yes null 15 null NO NO NO
NOTES_COUNT NUMBER Yes null 16 null NO NO NO
BRIEFED_COUNT NUMBER Yes null 17 null NO NO NO
OTHER_COUNT NUMBER Yes null 18 null NO NO NO
OTHERPRE_COUNT NUMBER Yes null 19 null NO NO NO
DISC_SUBJECT_COUNT NUMBER Yes null 20 null NO NO NO
DISC_VICTIM_COUNT NUMBER Yes null 21 null NO NO NO
DISC_WITNESS_COUNT NUMBER Yes null 22 null NO NO NO
MAG_COUNT NUMBER Yes null 23 null NO NO NO
CUST_AGENCY_COUNT NUMBER Yes null 24 null NO NO NO
POC_COUNT NUMBER Yes null 25 null NO NO NO
SUBJECT NUMBER Yes null 26 null NO NO NO
CLOSED_ON DATE Yes null 27 null NO NO NO
CLOSED_ON_FY NUMBER Yes null 28 null NO NO NO
NEXT_DUE_DATE DATE Yes null 29 null NO NO NO
FINAL_DUE_DATE DATE Yes null 30 null NO NO NO
FINAL_DUE_DATE_FY NUMBER Yes null 31 null NO NO NO
FINAL_DUE_DATE_MET VARCHAR2(3) Yes null 32 null NO NO NO
OBJ VARCHAR2(20) No null 1 null NO NO NO
ID VARCHAR2(100) Yes null 2 null NO NO NO
PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE



References


NAME VALUE
CREATED 12-APR-23
LAST_DDL_TIME 05-FEB-25
OWNER QART
VIEW_NAME V_SIII_INV_ACTS
TEXT_LENGTH 8180
TEXT SELECT DISTINCT O.SID OBJ,                    O.ID ID,                    OT.DISPLAY ACTIVITY_TYPE,                    O.TAGLINE TITLE,                    O.CREATED_ON CREATED_ON,                    O.CREATED_ON_FY CREATED_ON_FY,                    CASE                       WHEN S1.DISPLAY = 'Closed' THEN                          ( TRUNC(S.STARTED_ON) - TRUNC(O.CREATED_ON) )                       ELSE                          ( TRUNC(SYSDATE) - TRUNC(O.CREATED_ON) )                    END DAYS_OPEN,                    S1.DISPLAY STATUS,                    COALESCE(BRIEFING.ACTIVITY_DATE, COORD.ACTIVITY_DATE, DOC_REV.ACTIVITY_DATE, EXCEPTN.ACTIVITY_DATE) ACTIVITY_DATE,                    COALESCE(BRIEFING.ACTIVITY_DATE_FY, COORD.ACTIVITY_DATE_FY, DOC_REV.ACTIVITY_DATE_FY, EXCEPTN.ACTIVITY_DATE_FY) ACTIVITY_DATE_FY                    ,                    OU.SH_DISPLAY OWNING_UNIT,                    L.SH_DISPLAY LEAD,                    SO.SH_DISPLAY SUPPORT_PERSONNEL,                    ( SELECT COUNT(1)                          FROM MV_ACM_ASSOCIATION                       WHERE FROM_OBJ = O.SID                          OR TO_OBJ = O.SID                    ) ASSOCIATIONS_COUNT,                    ( SELECT COUNT(1)                          FROM MV_ACM_ATTACHMENT                       WHERE OBJ = O.SID                    ) ATTACHMENTS_COUNT,                    ( SELECT COUNT(1)                          FROM MV_ACM_NOTE                       WHERE OBJ = O.SID                    ) NOTES_COUNT,                    ( SELECT COUNT(1)                          FROM MV_PARTIC_INVOLVEMENT                       WHERE OBJ = O.SID                         AND INVOLVEMENT_ROLE IN ( SELECT SID                                                                            FROM MV_PARTIC_ROLE_TYPE                                                 WHERE CODE = 'BRIEFED'                                                 )                    ) BRIEFED_COUNT,                    ( SELECT COUNT(1)                          FROM MV_PARTIC_INVOLVEMENT                       WHERE OBJ = O.SID                         AND INVOLVEMENT_ROLE IN ( SELECT SID                                                                            FROM MV_PARTIC_ROLE_TYPE                                                 WHERE CODE = 'OTHER'                                                 )                    ) OTHER_COUNT,                    ( SELECT COUNT(1)                          FROM MV_PARTIC_INVOLVEMENT                       WHERE OBJ = O.SID                         AND INVOLVEMENT_ROLE IN ( SELECT SID                                                                            FROM MV_PARTIC_ROLE_TYPE                                                 WHERE CODE = 'OTHERPRE'                                                 )                    ) OTHERPRE_COUNT,                    ( SELECT COUNT(1)                          FROM MV_PARTIC_INVOLVEMENT                       WHERE OBJ = O.SID                         AND INVOLVEMENT_ROLE IN ( SELECT SID                                                                            FROM MV_PARTIC_ROLE_TYPE                                                 WHERE CODE = 'DISC_SUBJECT'                                                 )                    ) DISC_SUBJECT_COUNT,                    ( SELECT COUNT(1)                          FROM MV_PARTIC_INVOLVEMENT                       WHERE OBJ = O.SID                         AND INVOLVEMENT_ROLE IN ( SELECT SID                                                                            FROM MV_PARTIC_ROLE_TYPE                                                 WHERE CODE = 'DISC_VICTIM'                                                 )                    ) DISC_VICTIM_COUNT,                    ( SELECT COUNT(1)                          FROM MV_PARTIC_INVOLVEMENT                       WHERE OBJ = O.SID                         AND INVOLVEMENT_ROLE IN ( SELECT SID                                                                            FROM MV_PARTIC_ROLE_TYPE                                                 WHERE CODE = 'DISC_WITNESS'                                                 )                    ) DISC_WITNESS_COUNT,                    ( SELECT COUNT(1)                          FROM MV_PARTIC_INVOLVEMENT                       WHERE OBJ = O.SID                         AND INVOLVEMENT_ROLE IN ( SELECT SID                                                                            FROM MV_PARTIC_ROLE_TYPE                                                 WHERE CODE = 'MAG'                                                 )                    ) MAG_COUNT,                    ( SELECT COUNT(1)                          FROM MV_PARTIC_INVOLVEMENT                       WHERE OBJ = O.SID                         AND INVOLVEMENT_ROLE IN ( SELECT SID                                                                            FROM MV_PARTIC_ROLE_TYPE                                                 WHERE CODE = 'CUST_AGENCY'                                                 )                    ) CUST_AGENCY_COUNT,                    ( SELECT COUNT(1)                          FROM MV_PARTIC_INVOLVEMENT                       WHERE OBJ = O.SID                         AND INVOLVEMENT_ROLE IN ( SELECT SID                                                                            FROM MV_PARTIC_ROLE_TYPE                                                 WHERE CODE = 'POC'                                                 )                    ) POC_COUNT,                    ( SELECT COUNT(1)                          FROM MV_PARTIC_INVOLVEMENT                       WHERE OBJ = O.SID                         AND INVOLVEMENT_ROLE IN ( SELECT SID                                                                            FROM MV_PARTIC_ROLE_TYPE                                                 WHERE CODE = 'SUBJECT'                                                 )                    ) SUBJECT,                    CASE S.STATUS                       WHEN ( SELECT SID                                          FROM MV_ACM_STATUS                                  WHERE CODE = 'CLOSED'                               ) THEN                          S.STARTED_ON                       ELSE                          NULL                    END CLOSED_ON,                    CASE S.STATUS                       WHEN ( SELECT SID                                          FROM MV_ACM_STATUS                                  WHERE CODE = 'CLOSED'                               ) THEN                          S.STARTED_ON_FY                       ELSE                          NULL                    END CLOSED_ON_FY,                    O.NEXT_DUE_DATE,                    O.FINAL_DUE_DATE,                    O.FINAL_DUE_DATE_FY,                    CASE                       WHEN S1.DISPLAY = 'Closed'                          AND TRUNC(S.STARTED_ON) <= TRUNC(O.FINAL_DUE_DATE) THEN                          'Yes'                       ELSE                          'No'                    END FINAL_DUE_DATE_MET      FROM MV_ACM_OBJ O     INNER JOIN MV_ACM_OBJ_TYPE OT ON O.OBJ_TYPE = OT.SID       AND OT.OBJ_TYPE_CODE IN ( 'ACT.BRIEFING.ISD', 'ACT.DOC_REVIEW.ISD', 'ACT.EXCEPTION.ISD', 'ACT.COORD.ISD' )      LEFT JOIN MV_A_BRIEFING BRIEFING ON O.SID = BRIEFING.OBJ      LEFT JOIN MV_A_COORDINATION COORD ON O.SID = COORD.OBJ      LEFT JOIN MV_A_DOCUMENT_REVIEW DOC_REV ON O.SID = DOC_REV.OBJ      LEFT JOIN MV_A_EXCEPTION EXCEPTN ON O.SID = EXCEPTN.OBJ      LEFT JOIN MV_ACM_STATUS_HISTORY S ON O.SID = S.OBJ       AND S.COMPLETED_ON IS NULL      LEFT JOIN MV_ACM_STATUS S1 ON S1.SID = S.STATUS      LEFT JOIN MV_ACM_PLACE V ON O.SID = V.OBJ      LEFT JOIN V_CURR_OBJ_OWNING_UNIT OU ON O.SID = OU.OBJ      LEFT JOIN V_CURR_OBJ_LEAD_PERS L ON O.SID = L.OBJ      LEFT JOIN ( SELECT OBJ,                         LISTAGG(SH_DISPLAY,                                 ';' || CHR(13)) WITHIN GROUP(                          ORDER BY SH_DISPLAY)                         OVER(PARTITION BY OBJ) SH_DISPLAY                  FROM V_CURR_OBJ_SUPPORT_OFFICER                ) SO ON O.SID = SO.OBJ
TEXT_VC SELECT DISTINCT O.SID OBJ,                    O.ID ID,                    OT.DISPLAY ACTIVITY_TYPE,                    O.TAGLINE TITLE,                    O.CREATED_ON CREATED_ON,                    O.CREATED_ON_FY CREATED_ON_FY,                    CASE                       WHEN S1.DISPLAY = 'Closed' THEN                          ( TRUNC(S.STARTED_ON) - TRUNC(O.CREATED_ON) )                       ELSE                          ( TRUNC(SYSDATE) - TRUNC(O.CREATED_ON) )                    END DAYS_OPEN,                    S1.DISPLAY STATUS,                    COALESCE(BRIEFING.ACTIVITY_DATE, COORD.ACTIVITY_DATE, DOC_REV.ACTIVITY_DATE, EXCEPTN.ACTIVITY_DATE) ACTIVITY_DATE,                    COALESCE(BRIEFING.ACTIVITY_DATE_FY, COORD.ACTIVITY_DATE_FY, DOC_REV.ACTIVITY_DATE_FY, EXCEPTN.ACTIVITY_DATE_FY) ACTIVITY_DATE_FY                    ,                    OU.SH_DISPLAY OWNING_UNIT,                    L.SH_DISPLAY LEAD,                    SO.SH_DISPLAY SUPPORT_PERSONNEL,                    ( SELECT COUNT(1)                          FROM MV_ACM_ASSOCIATION                       WHERE FROM_OBJ = O.SID                          OR TO_OBJ = O.SID                    ) ASSOCIATIONS_COUNT,                    ( SELECT COUNT(1)                          FROM MV_ACM_ATTACHMENT                       WHERE OBJ = O.SID                    ) ATTACHMENTS_COUNT,                    ( SELECT COUNT(1)                          FROM MV_ACM_NOTE                       WHERE OBJ = O.SID                    ) NOTES_COUNT,                    ( SELECT COUNT(1)                          FROM MV_PARTIC_INVOLVEMENT                       WHERE OBJ = O.SID                         AND INVOLVEMENT_ROLE IN ( SELECT SID                                                                            FROM MV_PARTIC_ROLE_TYPE                                                 WHERE CODE = 'BRIEFED'                                                 )                    ) BRIEFED_COUNT,                    ( SELECT COUNT(1)                          FROM MV_PARTIC_INVOLVEMENT                       WHERE OBJ = O.SID                         AND INVOLVEMENT_ROLE IN ( SELECT SID                                                                            FROM MV_PARTIC_ROLE_TYPE                                                 WHERE CODE = 'OTHER'                                                 )                    ) OTHER_COUNT,                    ( SELECT COUNT(1)                          FROM MV_PARTIC_INVOLVEMENT                       WHERE OBJ = O.SID                         AND INVOLVEMENT_ROLE IN ( SELECT SID                                                                            FROM MV_PARTIC_ROLE_TYPE                                                 WHERE CODE = 'OTHERPRE'                                                 )                    ) OTHERPRE_COUNT,                    ( SELECT COUNT(1)                          FROM MV_PARTIC_INVOLVEMENT                       WHERE OBJ = O.SID                         AND INVOLVEMENT_ROLE IN ( SELECT SID                                                                            FROM MV_PARTIC_ROLE_TYPE                                                 WHERE CODE = 'DISC_SUBJECT'                                                 )                    ) DISC_SUBJECT_COUNT,                    ( SELECT COUNT(1)                          FROM MV_PARTIC_INVOLVEMENT                       WHERE OBJ = O.SID                         AND INVOLVEMENT_ROLE IN ( SELECT SID                                                                            FROM MV_PARTIC_ROLE_TYPE                                                 WHERE CODE = 'DISC_VICTIM'                                                 )                    ) DISC_VICTIM_COUNT,                    ( SELECT COUNT(1)                          FROM MV_PARTIC_INVOLVEMENT                       WHERE OBJ = O.SID                         AND INVOLVEMENT_ROLE IN ( SELECT SID                                            
TYPE_TEXT_LENGTH null
TYPE_TEXT null
OID_TEXT_LENGTH null
OID_TEXT null
VIEW_TYPE_OWNER null
VIEW_TYPE null
SUPERVIEW_NAME null
EDITIONING_VIEW N
READ_ONLY N
CONTAINER_DATA N
BEQUEATH DEFINER
ORIGIN_CON_ID 16
DEFAULT_COLLATION USING_NLS_COMP
CONTAINERS_DEFAULT NO
CONTAINER_MAP NO
EXTENDED_DATA_LINK NO
EXTENDED_DATA_LINK_MAP NO
HAS_SENSITIVE_COLUMN NO
ADMIT_NULL NO
PDB_LOCAL_ONLY NO
DUPLICATED N
SHARDED N
OWNER TRIGGER_NAME TRIGGER_TYPE TRIGGERING_EVENT STATUS OBJECT_ID




ATTRIBUTE Line:Position TEXT